{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Cost Worksheet","Scoring Formula"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":37,"n_cols":3,"rows_kept":37,"merged":[[1,1,1,2],[2,1,2,2],[5,1,5,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[17,1,17,2],[19,1,21,2],[22,1,22,2],[29,1,29,2]]}
[]
[null,"State of Georgia"]
[null,"In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[null,"Attachment X - Pharmacy FWA Audit Services Cost Worksheet"]
[]
[null,"Instructions for Supplier"]
[null,"\nSuppliers are bidding on the Design, Development and Implementation (DDI), monthly Operations and Maintenance (O&M) costs, and additional program support the Supplier will charge to administer the Pharmacy Fraud, Waste and Abuse (FWA) Audit Services as described in the eRFP. Please refer to the instructions below, Attachment A eRFP document \"Section 5, Cost Proposal,\" Attachment C - Common Scope Requirements and Security Standards, and Attachment H - Pharmacy Fraud, Waste and Abuse Audit Services Scope of Work for details describing the scope to be provided before completing this Cost Worksheet."]
[null,1,"Supplier shall provide firm/fixed pricing for the service(s) and deliverables for which a response is being submitted to as described in the eRFP."]
[null,2,"Suppliers shall complete the Cost Proposal worksheet using the cells highlighted in yellow."]
[null,3,"Suppliers shall not modify any cells in the spreadsheet other than those highlighted yellow. The other cells are fixed or will calculate automatically."]
[null,5,"Suppliers shall not modify the formulas in the worksheets."]
[null,4,"Suppliers shall insert 0 in any yellow highlighted cells that are not applicable or for which the proposed cost is zero ($0)."]
[null,6,"For evaluation purposes, the total cost will be determined by the value found in D14 which is comprised of the total DDI (Table A) and O&M (including all Tiers of Tables B.1, B.2, B.3, and B.4) Costs over a period of ten (10) years."]
[]
[null,"Instructions for Adjusting Costs One or More Years After the Effective Date of the Master Agreement  "]
[]
[null,"For Participating Addenda signed one year or more years after the Effective Date of the Master Agreement, the cost will be adjusted using the Consumer Price Index Urban (CPI-U) to account for economic changes that may impact cost. "]
[]
[]
[null,"CPI-U for United States Adjustment Factor Calculation:"]
[null,"CPI-U Index for the month and year of the execution of a Participating Addendum"]
[null,"Less the CPI-U Index for the month and year of the Effective Date of the Master Agreement"]
[null,"Equals Index Point Change"]
[null,"Divided by CPI-U Index B: C/B = D"]
[null,"Result multiplied by 100: D*100 = E: Equals CPI-U Inflation Percentage"]
[null," "]
[null,"Steps to Adjust Costs for CPI-U"]
[null,1,"Follow the link below to access the CPI-U data."]
[null,null,"https://www.bls.gov/cpi/tables/supplemental-files/home.htm"]
[null,2,"Select, download and save the file with the most recently published CPI-U data that is available for the month the Participating Addendum is signed. (Also find and select the CPI-U for when the Master Agreement was originally executed). Use the “All Items” CPI-U “Unadjusted indexes” values instead of the “Seasonally adjusted indexes” values."]
[null,3,"Enter the CPI-U value from the previous step in field C82 \"CPI-U for Participating Addendum Date.\""]
[null,4,"Enter the CPI-U value for the month of the Effective Date of the Master Agreement in C81 \"CPI-U for Master Agreement Date MM/DD/20YY.\" "]
[null,5,"The “CPI-U Inflation Percentage” will be calculated automatically based on the values from steps 3 and 4. This will also automatically update all the CPI-U Adjusted Price fields in the cost tables."]
[null,6,"CPI-U Adjusted Prices will be subject to negotiation upon execution of a Participating Addendum."]

{"sheet":"Cost Worksheet","index":1,"n_rows":116,"n_cols":26,"rows_kept":116,"merged":[[2,1,2,2],[5,1,5,2],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[13,5,13,6],[17,1,17,3],[24,1,24,2],[28,1,29,3],[28,4,28,5],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[28,14,28,15],[28,16,28,17],[28,18,28,19],[28,20,28,21],[28,22,28,23],[28,24,29,24],[28,25,29,25],[33,1,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[33,12,33,13],[33,14,33,15],[33,16,33,17],[33,18,33,19],[33,20,33,21],[33,22,33,23],[37,1,37,3],[37,4,37,5],[37,6,37,7],[37,8,37,9],[37,10,37,11],[37,12,37,13],[37,14,37,15],[37,16,37,17],[37,18,37,19],[37,20,37,21],[37,22,37,23],[41,1,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[41,10,41,11],[41,12,41,13],[41,14,41,15],[41,16,41,17],[41,18,41,19],[41,20,41,21],[41,22,41,23],[42,1,42,25],[45,1,46,3],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[45,12,45,13],[45,14,45,15],[45,16,45,17],[45,18,45,19],[45,20,45,21],[45,22,45,23],[45,24,46,24],[45,25,46,25],[50,1,50,3],[50,4,50,5],[50,6,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,13],[50,14,50,15],[50,16,50,17],[50,18,50,19],[50,20,50,21],[50,22,50,23],[54,1,54,3],[54,4,54,5],[54,6,54,7],[54,8,54,9],[54,10,54,11],[54,12,54,13],[54,14,54,15],[54,16,54,17],[54,18,54,19],[54,20,54,21],[54,22,54,23],[58,1,58,3],[58,4,58,5],[58,6,58,7],[58,8,58,9],[58,10,58,11],[58,12,58,13],[58,14,58,15],[58,16,58,17],[58,18,58,19],[58,20,58,21],[58,22,58,23],[59,1,59,25],[62,1,63,3],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[62,12,62,13],[62,14,62,15],[62,16,62,17],[62,18,62,19],[62,20,62,21],[62,22,62,23],[62,24,63,24],[62,25,63,25],[65,1,65,2],[67,1,67,3],[67,4,67,5],[67,6,67,7],[67,8,67,9],[67,10,67,11],[67,12,67,13],[67,14,67,15],[67,16,67,17],[67,18,67,19],[67,20,67,21],[67,22,67,23],[69,1,69,2],[71,1,71,3],[71,4,71,5],[71,6,71,7],[71,8,71,9],[71,10,71,11],[71,12,71,13],[71,14,71,15],[71,16,71,17],[71,18,71,19],[71,20,71,21],[71,22,71,23],[73,1,73,2],[75,1,75,3],[75,4,75,5],[75,6,75,7],[75,8,75,9],[75,10,75,11],[75,12,75,13],[75,14,75,15],[75,16,75,17],[75,18,75,19],[75,20,75,21],[75,22,75,23],[76,1,76,25],[80,1,81,3],[80,4,80,5],[80,6,80,7],[80,8,80,9],[80,10,80,11],[80,12,80,13],[80,14,80,15],[80,16,80,17],[80,18,80,19],[80,20,80,21],[80,22,80,23],[80,24,81,24],[80,25,81,25],[83,1,83,2],[85,1,85,3],[85,4,85,5],[85,6,85,7],[85,8,85,9],[85,10,85,11],[85,12,85,13],[85,14,85,15],[85,16,85,17],[85,18,85,19],[85,20,85,21],[85,22,85,23],[87,1,87,2],[89,1,89,3],[89,4,89,5],[89,6,89,7],[89,8,89,9],[89,10,89,11],[89,12,89,13],[89,14,89,15],[89,16,89,17],[89,18,89,19],[89,20,89,21],[89,22,89,23],[91,1,91,2],[93,1,93,3],[93,4,93,5],[93,6,93,7],[93,8,93,9],[93,10,93,11],[93,12,93,13],[93,14,93,15],[93,16,93,17],[93,18,93,19],[93,20,93,21],[93,22,93,23],[94,1,94,25],[98,1,98,3],[99,1,99,3],[99,4,99,5],[99,6,99,7],[99,8,99,9],[99,10,99,11],[99,12,99,13],[99,14,99,15],[99,16,99,17],[99,18,99,19],[99,20,99,21],[99,22,99,23],[99,24,100,24],[100,2,100,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[105,1,106,23],[105,24,106,24],[107,1,107,24]]}
[]
[" ","State of Georgia"]
[" ","In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[" ","Attachment X - Pharmacy FWA Audit Services Cost Worksheet"]
[" "," "]
[" ","SUPPLIER LEGAL ENTITY NAME:","Magellan Medicaid Administration, LLC"]
[null,"SUPPLIER REPRESENTATIVE NAME:","Billy Thomas"]
[" ","SUPPLIER REPRESENTATIVE TITLE:","SVP, Account Management"]
[null,"DATE:","2024-04-30"]
[" "]
[null,"TOTAL EVALUATION COST AMOUNT (Sum of Evaluation Costs Below, including Table A and all Tiers of Tables B.1-B.4):",{"$nulls":3},{"$f":"D25+Y34+Y38+Y42+Y51+Y55+Y59+Y68+Y72+Y76+Y86+Y90+Y94","v":{"v":102408453.61,"d":"$102,408,453.61"}}]
[" ",null," "]
[null,"Table A"]
[null,"Instructions: Please enter the costs to implement your services and/or Solution."]
[null,"Service Design, Development, and Implementation (DDI) Cost"]
[null,null,"Initial Cost","CPI-U Adjusted Cost"]
[null,"Project Planning and Startup",{"v":69282.84,"d":"$69,282.84"},{"$f":"+C20*$C$116","v":{"v":69282.84,"d":"$69,282.84"}}]
[null,"Design, Development, and Testing",{"v":123410.05,"d":"$123,410.05"},{"$f":"+C21*$C$116","v":{"v":123410.05,"d":"$123,410.05"}}]
[null,"Operational Readiness and Production Cutover",{"v":112584.61,"d":"$112,584.61"},{"$f":"+C22*$C$116","v":{"v":112584.61,"d":"$112,584.61"}}]
[null,"Training",{"v":80108.28,"d":"$80,108.28"},{"$f":"+C23*$C$116","v":{"v":80108.28,"d":"$80,108.28"}}]
[null,"Acceptance, Deployment",{"v":47631.95,"d":"$47,631.95"},{"$f":"+C24*$C$116","v":{"v":47631.95,"d":"$47,631.95"}}]
[null,"Total DDI Costs:",null,{"$f":"SUM(D20:D24)","v":{"v":433017.73000000004,"d":"$433,017.73"}}]
[]
[]
[null,"Table B.1"]
[null,"Desk Audit Administrative Fee \nThe monthly administration fee should include all the O&M costs to provide the Desk Audit services required as described in the scope of work.",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Total for Pharmacy Fraud, Waste and Abuse Audit Services O&M Desk Audit Administration","For Informational Purposes Only\nAnnual Average Desk Audit Administration Cost"]
[{"$nulls":4},"Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate"]
[null,"Tier 1 Desk Audit Monthly Administrative Fee"]
[null,"To support a maximum of 1,500 Desk Audits per Year",null,"Total Monthly Cost",{"v":98705.5,"d":"$98,705.50"},{"$f":"E32*$C$116","v":{"v":98705.5,"d":"$98,705.50"}},{"v":101667.26,"d":"$101,667.26"},{"$f":"G32*$C$116","v":{"v":101667.26,"d":"$101,667.26"}},{"v":104717.28,"d":"$104,717.28"},{"$f":"I32*$C$116","v":{"v":104717.28,"d":"$104,717.28"}},{"v":107858.8,"d":"$107,858.80"},{"$f":"K32*$C$116","v":{"v":107858.8,"d":"$107,858.80"}},{"v":111094.56,"d":"$111,094.56"},{"$f":"M32*$C$116","v":{"v":111094.56,"d":"$111,094.56"}},{"v":114427.4,"d":"$114,427.40"},{"$f":"O32*$C$116","v":{"v":114427.4,"d":"$114,427.40"}},{"v":117860.22,"d":"$117,860.22"},{"$f":"Q32*$C$116","v":{"v":117860.22,"d":"$117,860.22"}},{"v":121396.03,"d":"$121,396.03"},{"$f":"S32*$C$116","v":{"v":121396.03,"d":"$121,396.03"}},{"v":125037.91,"d":"$125,037.91"},{"$f":"U32*$C$116","v":{"v":125037.91,"d":"$125,037.91"}},{"v":128789.05,"d":"$128,789.05"},{"$f":"W32*$C$116","v":{"v":128789.05,"d":"$128,789.05"}}]
[{"$nulls":4},"X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months"]
[null,"Tier 1 Evaluation Cost ",null,null,{"$f":"F32*12","v":{"v":1184466,"d":"= $ 1,184,466"}},null,{"$f":"H32*12","v":{"v":1220007.1199999999,"d":"= $ 1,220,007"}},null,{"$f":"J32*12","v":{"v":1256607.3599999999,"d":"= $ 1,256,607"}},null,{"$f":"L32*12","v":{"v":1294305.6,"d":"= $ 1,294,306"}},null,{"$f":"N32*12","v":{"v":1333134.72,"d":"= $ 1,333,135"}},null,{"$f":"P32*12","v":{"v":1373128.7999999998,"d":"= $ 1,373,129"}},null,{"$f":"R32*12","v":{"v":1414322.6400000001,"d":"= $ 1,414,323"}},null,{"$f":"T32*12","v":{"v":1456752.3599999999,"d":"= $ 1,456,752"}},null,{"$f":"V32*12","v":{"v":1500454.92,"d":"= $ 1,500,455"}},null,{"$f":"X32*12","v":{"v":1545468.6,"d":"= $ 1,545,469"}},null,{"$f":"SUM(E34:W34)","v":{"v":13578648.12,"d":"=$13,578,648"}},{"$f":"Y34/10","v":{"v":1357864.812,"d":"=$1,357,865"}}]
[null,"Tier 2 Desk Audit Monthly Administrative Fee"]
[null,"To support between 1,501-3,000 Desk Audits per Year",null,"Total Monthly Cost",{"v":168610.28,"d":"$168,610.28"},{"$f":"E36*$C$116","v":{"v":168610.28,"d":"$168,610.28"}},{"v":173668.32,"d":"$173,668.32"},{"$f":"G36*$C$116","v":{"v":173668.32,"d":"$173,668.32"}},{"v":178878.41,"d":"$178,878.41"},{"$f":"I36*$C$116","v":{"v":178878.41,"d":"$178,878.41"}},{"v":184244.8,"d":"$184,244.80"},{"$f":"K36*$C$116","v":{"v":184244.8,"d":"$184,244.80"}},{"v":189772.16,"d":"$189,772.16"},{"$f":"M36*$C$116","v":{"v":189772.16,"d":"$189,772.16"}},{"v":195465.34,"d":"$195,465.34"},{"$f":"O36*$C$116","v":{"v":195465.34,"d":"$195,465.34"}},{"v":201329.32,"d":"$201,329.32"},{"$f":"Q36*$C$116","v":{"v":201329.32,"d":"$201,329.32"}},{"v":207369.25,"d":"$207,369.25"},{"$f":"S36*$C$116","v":{"v":207369.25,"d":"$207,369.25"}},{"v":213590.38,"d":"$213,590.38"},{"$f":"U36*$C$116","v":{"v":213590.38,"d":"$213,590.38"}},{"v":219998.15,"d":"$219,998.15"},{"$f":"W36*$C$116","v":{"v":219998.15,"d":"$219,998.15"}}]
[{"$nulls":4},"X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months"]
[null,"Tier 2 Evaluation Cost ",null,null,{"$f":"F36*12","v":{"v":2023323.3599999999,"d":"=$2,023,323"}},null,{"$f":"H36*12","v":{"v":2084019.84,"d":"=$2,084,020"}},null,{"$f":"J36*12","v":{"v":2146540.92,"d":"=$2,146,541"}},null,{"$f":"L36*12","v":{"v":2210937.5999999996,"d":"=$2,210,938"}},null,{"$f":"N36*12","v":{"v":2277265.92,"d":"=$2,277,266"}},null,{"$f":"P36*12","v":{"v":2345584.08,"d":"=$2,345,584"}},null,{"$f":"R36*12","v":{"v":2415951.84,"d":"=$2,415,952"}},null,{"$f":"T36*12","v":{"v":2488431,"d":"=$2,488,431"}},null,{"$f":"V36*12","v":{"v":2563084.56,"d":"=$2,563,085"}},null,{"$f":"X36*12","v":{"v":2639977.8,"d":"=$2,639,978"}},null,{"$f":"SUM(E38:W38)","v":{"v":23195116.919999998,"d":"=$23,195,117"}},{"$f":"Y38/10","v":{"v":2319511.692,"d":"=$2,319,512"}}]
[null,"Tier 3 Desk Audit Monthly Administrative Fee"]
[null,"To support a minimum of 3,001 Desk Audits per Year",null,"Total Monthly Cost",{"v":244014.19,"d":"$244,014.19"},{"$f":"E40*$C$116","v":{"v":244014.19,"d":"$244,014.19"}},{"v":251334.61,"d":"$251,334.61"},{"$f":"G40*$C$116","v":{"v":251334.61,"d":"$251,334.61"}},{"v":258874.65,"d":"$258,874.65"},{"$f":"I40*$C$116","v":{"v":258874.65,"d":"$258,874.65"}},{"v":266640.89,"d":"$266,640.89"},{"$f":"K40*$C$116","v":{"v":266640.89,"d":"$266,640.89"}},{"v":274640.12,"d":"$274,640.12"},{"$f":"M40*$C$116","v":{"v":274640.12,"d":"$274,640.12"}},{"v":282879.32,"d":"$282,879.32"},{"$f":"O40*$C$116","v":{"v":282879.32,"d":"$282,879.32"}},{"v":291365.7,"d":"$291,365.70"},{"$f":"Q40*$C$116","v":{"v":291365.7,"d":"$291,365.70"}},{"v":300106.67,"d":"$300,106.67"},{"$f":"S40*$C$116","v":{"v":300106.67,"d":"$300,106.67"}},{"v":309109.87,"d":"$309,109.87"},{"$f":"U40*$C$116","v":{"v":309109.87,"d":"$309,109.87"}},{"v":318383.17,"d":"$318,383.17"},{"$f":"W40*$C$116","v":{"v":318383.17,"d":"$318,383.17"}}]
[{"$nulls":4},"X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months"]
[null,"Tier 3 Evaluation Cost",null,null,{"$f":"F40*12","v":{"v":2928170.2800000003,"d":"=$2,928,170"}},null,{"$f":"H40*12","v":{"v":3016015.32,"d":"=$3,016,015"}},null,{"$f":"J40*12","v":{"v":3106495.8,"d":"=$3,106,496"}},null,{"$f":"L40*12","v":{"v":3199690.68,"d":"=$3,199,691"}},null,{"$f":"N40*12","v":{"v":3295681.44,"d":"=$3,295,681"}},null,{"$f":"P40*12","v":{"v":3394551.84,"d":"=$3,394,552"}},null,{"$f":"R40*12","v":{"v":3496388.4000000004,"d":"=$3,496,388"}},null,{"$f":"T40*12","v":{"v":3601280.04,"d":"=$3,601,280"}},null,{"$f":"V40*12","v":{"v":3709318.44,"d":"=$3,709,318"}},null,{"$f":"X40*12","v":{"v":3820598.04,"d":"=$3,820,598"}},null,{"$f":"SUM(E42:W42)","v":{"v":33568190.28,"d":"=$33,568,190"}},{"$f":"Y42/10","v":{"v":3356819.028,"d":"=$3,356,819"}}]
[]
[]
[null,"Table B.2"]
[null,"Field Audit Administrative Fee \nThe monthly administration fee should include all the O&M costs to provide the Field Audit services required as described in the scope of work.",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Total for Pharmacy Fraud, Waste and Abuse Audit Services O&M Field Audit Administration","For Informational Purposes Only\nAnnual Average Field Audit Administration Cost"]
[{"$nulls":4},"Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate"]
[null,"Tier 1 Field Audit Monthly Administrative Fee"]
[null,"To support a maximum of 150 Field Audits per Year",null,"Total Monthly Cost",{"v":18470.19,"d":"$18,470.19"},{"$f":"E49*$C$116","v":{"v":18470.19,"d":"$18,470.19"}},{"v":19027.44,"d":"$19,027.44"},{"$f":"G49*$C$116","v":{"v":19027.44,"d":"$19,027.44"}},{"v":19598.26,"d":"$19,598.26"},{"$f":"I49*$C$116","v":{"v":19598.26,"d":"$19,598.26"}},{"v":20186.21,"d":"$20,186.21"},{"$f":"K49*$C$116","v":{"v":20186.21,"d":"$20,186.21"}},{"v":20791.8,"d":"$20,791.80"},{"$f":"M49*$C$116","v":{"v":20791.8,"d":"$20,791.80"}},{"v":21415.55,"d":"$21,415.55"},{"$f":"O49*$C$116","v":{"v":21415.55,"d":"$21,415.55"}},{"v":22058.02,"d":"$22,058.02"},{"$f":"Q49*$C$116","v":{"v":22058.02,"d":"$22,058.02"}},{"v":22719.76,"d":"$22,719.76"},{"$f":"S49*$C$116","v":{"v":22719.76,"d":"$22,719.76"}},{"v":23401.35,"d":"$23,401.35"},{"$f":"U49*$C$116","v":{"v":23401.35,"d":"$23,401.35"}},{"v":24103.39,"d":"$24,103.39"},{"$f":"W49*$C$116","v":{"v":24103.39,"d":"$24,103.39"}}]
[{"$nulls":5},"months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months"]
[null,"Tier 1 Evaluation Cost ",null,null,{"$f":"F49*12","v":{"v":221642.27999999997,"d":"= $ 221,642"}},null,{"$f":"H49*12","v":{"v":228329.27999999997,"d":"= $ 228,329"}},null,{"$f":"J49*12","v":{"v":235179.12,"d":"= $ 235,179"}},null,{"$f":"L49*12","v":{"v":242234.52,"d":"= $ 242,235"}},null,{"$f":"N49*12","v":{"v":249501.59999999998,"d":"= $ 249,502"}},null,{"$f":"P49*12","v":{"v":256986.59999999998,"d":"= $ 256,987"}},null,{"$f":"R49*12","v":{"v":264696.24,"d":"= $ 264,696"}},null,{"$f":"T49*12","v":{"v":272637.12,"d":"= $ 272,637"}},null,{"$f":"V49*12","v":{"v":280816.19999999995,"d":"= $ 280,816"}},null,{"$f":"X49*12","v":{"v":289240.68,"d":"= $ 289,241"}},null,{"$f":"SUM(E51:W51)","v":{"v":2541263.64,"d":"=$2,541,264"}},{"$f":"Y51/10","v":{"v":254126.364,"d":"=$254,126"}}]
[null,"Tier 2 Field Audit Monthly Administrative Fee"]
[null,"To support between 151-300 Field Audits per Year",null,"Total Monthly Cost",{"v":31551.08,"d":"$31,551.08"},{"$f":"E53*$C$116","v":{"v":31551.08,"d":"$31,551.08"}},{"v":32497.56,"d":"$32,497.56"},{"$f":"G53*$C$116","v":{"v":32497.56,"d":"$32,497.56"}},{"v":33472.49,"d":"$33,472.49"},{"$f":"I53*$C$116","v":{"v":33472.49,"d":"$33,472.49"}},{"v":34476.67,"d":"$34,476.67"},{"$f":"K53*$C$116","v":{"v":34476.67,"d":"$34,476.67"}},{"v":35510.98,"d":"$35,510.98"},{"$f":"M53*$C$116","v":{"v":35510.98,"d":"$35,510.98"}},{"v":36576.31,"d":"$36,576.31"},{"$f":"O53*$C$116","v":{"v":36576.31,"d":"$36,576.31"}},{"v":37673.6,"d":"$37,673.60"},{"$f":"Q53*$C$116","v":{"v":37673.6,"d":"$37,673.60"}},{"v":38803.82,"d":"$38,803.82"},{"$f":"S53*$C$116","v":{"v":38803.82,"d":"$38,803.82"}},{"v":39967.94,"d":"$39,967.94"},{"$f":"U53*$C$116","v":{"v":39967.94,"d":"$39,967.94"}},{"v":41166.99,"d":"$41,166.99"},{"$f":"W53*$C$116","v":{"v":41166.99,"d":"$41,166.99"}}]
[{"$nulls":4},"X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months"]
[null,"Tier 2 Evaluation Cost ",null,null,{"$f":"F53*12","v":{"v":378612.96,"d":"=$378,613"}},null,{"$f":"H53*12","v":{"v":389970.72000000003,"d":"=$389,971"}},null,{"$f":"J53*12","v":{"v":401669.88,"d":"=$401,670"}},null,{"$f":"L53*12","v":{"v":413720.04,"d":"=$413,720"}},null,{"$f":"N53*12","v":{"v":426131.76,"d":"=$426,132"}},null,{"$f":"P53*12","v":{"v":438915.72,"d":"=$438,916"}},null,{"$f":"R53*12","v":{"v":452083.19999999995,"d":"=$452,083"}},null,{"$f":"T53*12","v":{"v":465645.83999999997,"d":"=$465,646"}},null,{"$f":"V53*12","v":{"v":479615.28,"d":"=$479,615"}},null,{"$f":"X53*12","v":{"v":494003.88,"d":"=$494,004"}},null,{"$f":"SUM(E55:W55)","v":{"v":4340369.28,"d":"=$4,340,369"}},{"$f":"Y55/10","v":{"v":434036.928,"d":"=$434,037"}}]
[null,"Tier 3 Field Audit Monthly Administrative Fee"]
[null,"To support a minimum of 301 Field Audits per Year",null,"Total Monthly Cost",{"v":45660.98,"d":"$45,660.98"},{"$f":"E57*$C$116","v":{"v":45660.98,"d":"$45,660.98"}},{"v":47030.81,"d":"$47,030.81"},{"$f":"G57*$C$116","v":{"v":47030.81,"d":"$47,030.81"}},{"v":48441.73,"d":"$48,441.73"},{"$f":"I57*$C$116","v":{"v":48441.73,"d":"$48,441.73"}},{"v":49894.98,"d":"$49,894.98"},{"$f":"K57*$C$116","v":{"v":49894.98,"d":"$49,894.98"}},{"v":51391.83,"d":"$51,391.83"},{"$f":"M57*$C$116","v":{"v":51391.83,"d":"$51,391.83"}},{"v":52933.59,"d":"$52,933.59"},{"$f":"O57*$C$116","v":{"v":52933.59,"d":"$52,933.59"}},{"v":54521.59,"d":"$54,521.59"},{"$f":"Q57*$C$116","v":{"v":54521.59,"d":"$54,521.59"}},{"v":56157.24,"d":"$56,157.24"},{"$f":"S57*$C$116","v":{"v":56157.24,"d":"$56,157.24"}},{"v":57841.96,"d":"$57,841.96"},{"$f":"U57*$C$116","v":{"v":57841.96,"d":"$57,841.96"}},{"v":59577.22,"d":"$59,577.22"},{"$f":"W57*$C$116","v":{"v":59577.22,"d":"$59,577.22"}}]
[{"$nulls":4},"X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months"]
[null,"Tier 3 Evaluation Cost",null,null,{"$f":"F57*12","v":{"v":547931.76,"d":"=$547,932"}},null,{"$f":"H57*12","v":{"v":564369.72,"d":"=$564,370"}},null,{"$f":"J57*12","v":{"v":581300.76,"d":"=$581,301"}},null,{"$f":"L57*12","v":{"v":598739.76,"d":"=$598,740"}},null,{"$f":"N57*12","v":{"v":616701.96,"d":"=$616,702"}},null,{"$f":"P57*12","v":{"v":635203.08,"d":"=$635,203"}},null,{"$f":"R57*12","v":{"v":654259.08,"d":"=$654,259"}},null,{"$f":"T57*12","v":{"v":673886.88,"d":"=$673,887"}},null,{"$f":"V57*12","v":{"v":694103.52,"d":"=$694,104"}},null,{"$f":"X57*12","v":{"v":714926.64,"d":"=$714,927"}},null,{"$f":"SUM(E59:W59)","v":{"v":6281423.159999999,"d":"=$6,281,423"}},{"$f":"Y59/10","v":{"v":628142.3159999999,"d":"=$628,142"}}]
[]
[]
[null,"Table B.3"]
[null,"Concurrent Audit Administrative Fee \nThe monthly administration fee should include all the O&M costs to provide the Field Audit services required as described in the scope of work.",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Total for Pharmacy Fraud, Waste and Abuse Audit Services O&M Concurrent Audit Administration","For Informational Purposes Only\nAnnual Average Concurrent Audit Administration Cost"]
[{"$nulls":4},"Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate"]
[null,"Tier 1 Concurrent Audit Monthly Administrative Fee"]
[null,"To support a maximum of 15,000 Concurrent Audits per Year",null,"Total Monthly Cost",{"v":15125.74,"d":"$15,125.74"},{"$f":"E66*$C$116","v":{"v":15125.74,"d":"$15,125.74"}},{"v":15579.55,"d":"$15,579.55"},{"$f":"G66*$C$116","v":{"v":15579.55,"d":"$15,579.55"}},{"v":16046.93,"d":"$16,046.93"},{"$f":"I66*$C$116","v":{"v":16046.93,"d":"$16,046.93"}},{"v":16528.34,"d":"$16,528.34"},{"$f":"K66*$C$116","v":{"v":16528.34,"d":"$16,528.34"}},{"v":17024.19,"d":"$17,024.19"},{"$f":"M66*$C$116","v":{"v":17024.19,"d":"$17,024.19"}},{"v":17534.92,"d":"$17,534.92"},{"$f":"O66*$C$116","v":{"v":17534.92,"d":"$17,534.92"}},{"v":18060.97,"d":"$18,060.97"},{"$f":"Q66*$C$116","v":{"v":18060.97,"d":"$18,060.97"}},{"v":18602.8,"d":"$18,602.80"},{"$f":"S66*$C$116","v":{"v":18602.8,"d":"$18,602.80"}},{"v":19160.88,"d":"$19,160.88"},{"$f":"U66*$C$116","v":{"v":19160.88,"d":"$19,160.88"}},{"v":19735.71,"d":"$19,735.71"},{"$f":"W66*$C$116","v":{"v":19735.71,"d":"$19,735.71"}}]
[{"$nulls":4},"X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months"]
[null,"Tier 1 Evaluation Cost ",null,null,{"$f":"F66*12","v":{"v":181508.88,"d":"= $ 181,509"}},null,{"$f":"H66*12","v":{"v":186954.59999999998,"d":"= $ 186,955"}},null,{"$f":"J66*12","v":{"v":192563.16,"d":"= $ 192,563"}},null,{"$f":"L66*12","v":{"v":198340.08000000002,"d":"= $ 198,340"}},null,{"$f":"N66*12","v":{"v":204290.27999999997,"d":"= $ 204,290"}},null,{"$f":"P66*12","v":{"v":210419.03999999998,"d":"= $ 210,419"}},null,{"$f":"R66*12","v":{"v":216731.64,"d":"= $ 216,732"}},null,{"$f":"T66*12","v":{"v":223233.59999999998,"d":"= $ 223,234"}},null,{"$f":"V66*12","v":{"v":229930.56,"d":"= $ 229,931"}},null,{"$f":"X66*12","v":{"v":236828.52,"d":"= $ 236,829"}},null,{"$f":"SUM(E68:W68)","v":{"v":2080800.3600000003,"d":"=$2,080,800"}},{"$f":"Y68/10","v":{"v":208080.03600000002,"d":"=$208,080"}}]
[null,"Tier 2 Concurrent Audit Monthly Administrative Fee"]
[null,"To support  between 15,001-30,000 Concurrent Audits per Year",null,"Total Monthly Cost",{"v":25838.02,"d":"$25,838.02"},{"$f":"E70*$C$116","v":{"v":25838.02,"d":"$25,838.02"}},{"v":26613.12,"d":"$26,613.12"},{"$f":"G70*$C$116","v":{"v":26613.12,"d":"$26,613.12"}},{"v":27411.52,"d":"$27,411.52"},{"$f":"I70*$C$116","v":{"v":27411.52,"d":"$27,411.52"}},{"v":28233.88,"d":"$28,233.88"},{"$f":"K70*$C$116","v":{"v":28233.88,"d":"$28,233.88"}},{"v":29080.89,"d":"$29,080.89"},{"$f":"M70*$C$116","v":{"v":29080.89,"d":"$29,080.89"}},{"v":29953.32,"d":"$29,953.32"},{"$f":"O70*$C$116","v":{"v":29953.32,"d":"$29,953.32"}},{"v":30851.93,"d":"$30,851.93"},{"$f":"Q70*$C$116","v":{"v":30851.93,"d":"$30,851.93"}},{"v":31777.49,"d":"$31,777.49"},{"$f":"S70*$C$116","v":{"v":31777.49,"d":"$31,777.49"}},{"v":32730.82,"d":"$32,730.82"},{"$f":"U70*$C$116","v":{"v":32730.82,"d":"$32,730.82"}},{"v":33712.76,"d":"$33,712.76"},{"$f":"W70*$C$116","v":{"v":33712.76,"d":"$33,712.76"}}]
[{"$nulls":4},"X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months"]
[null,"Tier 2 Evaluation Cost ",null,null,{"$f":"F70*12","v":{"v":310056.24,"d":"=$310,056"}},null,{"$f":"H70*12","v":{"v":319357.44,"d":"=$319,357"}},null,{"$f":"J70*12","v":{"v":328938.24,"d":"=$328,938"}},null,{"$f":"L70*12","v":{"v":338806.56,"d":"=$338,807"}},null,{"$f":"N70*12","v":{"v":348970.68,"d":"=$348,971"}},null,{"$f":"P70*12","v":{"v":359439.83999999997,"d":"=$359,440"}},null,{"$f":"R70*12","v":{"v":370223.16000000003,"d":"=$370,223"}},null,{"$f":"T70*12","v":{"v":381329.88,"d":"=$381,330"}},null,{"$f":"V70*12","v":{"v":392769.83999999997,"d":"=$392,770"}},null,{"$f":"X70*12","v":{"v":404553.12,"d":"=$404,553"}},null,{"$f":"SUM(E72:W72)","v":{"v":3554445,"d":"=$3,554,445"}},{"$f":"Y72/10","v":{"v":355444.5,"d":"=$355,445"}}]
[null,"Tier 3 Concurrent Audit Monthly Administrative Fee"]
[null,"To support a minimum of 30,001 Concurrent Audits per Year",null,"Total Monthly Cost",{"v":37393,"d":"$37,393.00"},{"$f":"E74*$C$116","v":{"v":37393,"d":"$37,393.00"}},{"v":38514.79,"d":"$38,514.79"},{"$f":"G74*$C$116","v":{"v":38514.79,"d":"$38,514.79"}},{"v":39670.24,"d":"$39,670.24"},{"$f":"I74*$C$116","v":{"v":39670.24,"d":"$39,670.24"}},{"v":40860.34,"d":"$40,860.34"},{"$f":"K74*$C$116","v":{"v":40860.34,"d":"$40,860.34"}},{"v":42086.15,"d":"$42,086.15"},{"$f":"M74*$C$116","v":{"v":42086.15,"d":"$42,086.15"}},{"v":43348.74,"d":"$43,348.74"},{"$f":"O74*$C$116","v":{"v":43348.74,"d":"$43,348.74"}},{"v":44649.2,"d":"$44,649.20"},{"$f":"Q74*$C$116","v":{"v":44649.2,"d":"$44,649.20"}},{"v":45988.68,"d":"$45,988.68"},{"$f":"S74*$C$116","v":{"v":45988.68,"d":"$45,988.68"}},{"v":47368.34,"d":"$47,368.34"},{"$f":"U74*$C$116","v":{"v":47368.34,"d":"$47,368.34"}},{"v":48789.39,"d":"$48,789.39"},{"$f":"W74*$C$116","v":{"v":48789.39,"d":"$48,789.39"}}]
[{"$nulls":4},"X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months"]
[null,"Tier 3 Evaluation Cost",null,null,{"$f":"F74*12","v":{"v":448716,"d":"=$448,716"}},null,{"$f":"H74*12","v":{"v":462177.48,"d":"=$462,177"}},null,{"$f":"J74*12","v":{"v":476042.88,"d":"=$476,043"}},null,{"$f":"L74*12","v":{"v":490324.07999999996,"d":"=$490,324"}},null,{"$f":"N74*12","v":{"v":505033.80000000005,"d":"=$505,034"}},null,{"$f":"P74*12","v":{"v":520184.88,"d":"=$520,185"}},null,{"$f":"R74*12","v":{"v":535790.3999999999,"d":"=$535,790"}},null,{"$f":"T74*12","v":{"v":551864.16,"d":"=$551,864"}},null,{"$f":"V74*12","v":{"v":568420.08,"d":"=$568,420"}},null,{"$f":"X74*12","v":{"v":585472.6799999999,"d":"=$585,473"}},null,{"$f":"SUM(E76:W76)","v":{"v":5144026.4399999995,"d":"=$5,144,026"}},{"$f":"Y76/10","v":{"v":514402.644,"d":"=$514,403"}}]
[]
[]
[]
[null,"Table B.4"]
[null,"Pharmacy Lock In (PLI) Administrative Fee \nThe monthly administration fee should include all the O&M costs to provide the PLI services required as described in the scope of work.",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Total for Pharmacy Fraud, Waste and Abuse Audit Services O&M PLI Services Administration","For Informational Purposes Only\nAnnual Average PLI Services Administration Cost"]
[{"$nulls":4},"Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate"]
[null,"Tier 1 PLI Services Monthly Administrative Fee"]
[null,"For a PLI program with a maximum of 100 Active Members ",null,"Total Monthly Cost",{"v":18635.87,"d":"$18,635.87"},{"$f":"E84*$C$116","v":{"v":18635.87,"d":"$18,635.87"}},{"v":19195.32,"d":"$19,195.32"},{"$f":"G84*$C$116","v":{"v":19195.32,"d":"$19,195.32"}},{"v":19771.18,"d":"$19,771.18"},{"$f":"I84*$C$116","v":{"v":19771.18,"d":"$19,771.18"}},{"v":20364.31,"d":"$20,364.31"},{"$f":"K84*$C$116","v":{"v":20364.31,"d":"$20,364.31"}},{"v":20975.24,"d":"$20,975.24"},{"$f":"M84*$C$116","v":{"v":20975.24,"d":"$20,975.24"}},{"v":21604.5,"d":"$21,604.50"},{"$f":"O84*$C$116","v":{"v":21604.5,"d":"$21,604.50"}},{"v":22252.63,"d":"$22,252.63"},{"$f":"Q84*$C$116","v":{"v":22252.63,"d":"$22,252.63"}},{"v":22920.21,"d":"$22,920.21"},{"$f":"S84*$C$116","v":{"v":22920.21,"d":"$22,920.21"}},{"v":23607.82,"d":"$23,607.82"},{"$f":"U84*$C$116","v":{"v":23607.82,"d":"$23,607.82"}},{"v":24316.05,"d":"$24,316.05"},{"$f":"W84*$C$116","v":{"v":24316.05,"d":"$24,316.05"}}]
[{"$nulls":4},"X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months"]
[null,"Tier 1 Evaluation Cost ",null,null,{"$f":"F84*12","v":{"v":223630.44,"d":"= $ 223,630"}},null,{"$f":"H84*12","v":{"v":230343.84,"d":"= $ 230,344"}},null,{"$f":"J84*12","v":{"v":237254.16,"d":"= $ 237,254"}},null,{"$f":"L84*12","v":{"v":244371.72000000003,"d":"= $ 244,372"}},null,{"$f":"N84*12","v":{"v":251702.88,"d":"= $ 251,703"}},null,{"$f":"P84*12","v":{"v":259254,"d":"= $ 259,254"}},null,{"$f":"R84*12","v":{"v":267031.56,"d":"= $ 267,032"}},null,{"$f":"T84*12","v":{"v":275042.52,"d":"= $ 275,043"}},null,{"$f":"V84*12","v":{"v":283293.83999999997,"d":"= $ 283,294"}},null,{"$f":"X84*12","v":{"v":291792.6,"d":"= $ 291,793"}},null,{"$f":"SUM(E86:W86)","v":{"v":2563717.56,"d":"=$2,563,718"}},{"$f":"Y86/10","v":{"v":256371.756,"d":"=$256,372"}}]
[null,"Tier 2 PLI Services Monthly Administrative Fee"]
[null,"For a PLI program with 101-250 Active Members",null,"Total Monthly Cost",{"v":18635.87,"d":"$18,635.87"},{"$f":"E88*$C$116","v":{"v":18635.87,"d":"$18,635.87"}},{"v":19195.32,"d":"$19,195.32"},{"$f":"G88*$C$116","v":{"v":19195.32,"d":"$19,195.32"}},{"v":19771.18,"d":"$19,771.18"},{"$f":"I88*$C$116","v":{"v":19771.18,"d":"$19,771.18"}},{"v":20364.31,"d":"$20,364.31"},{"$f":"K88*$C$116","v":{"v":20364.31,"d":"$20,364.31"}},{"v":20975.24,"d":"$20,975.24"},{"$f":"M88*$C$116","v":{"v":20975.24,"d":"$20,975.24"}},{"v":21604.5,"d":"$21,604.50"},{"$f":"O88*$C$116","v":{"v":21604.5,"d":"$21,604.50"}},{"v":22252.63,"d":"$22,252.63"},{"$f":"Q88*$C$116","v":{"v":22252.63,"d":"$22,252.63"}},{"v":22920.21,"d":"$22,920.21"},{"$f":"S88*$C$116","v":{"v":22920.21,"d":"$22,920.21"}},{"v":23607.82,"d":"$23,607.82"},{"$f":"U88*$C$116","v":{"v":23607.82,"d":"$23,607.82"}},{"v":24316.05,"d":"$24,316.05"},{"$f":"W88*$C$116","v":{"v":24316.05,"d":"$24,316.05"}}]
[{"$nulls":4},"X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months"]
[null,"Tier 2 Evaluation Cost ",null,null,{"$f":"F88*12","v":{"v":223630.44,"d":"=$223,630"}},null,{"$f":"H88*12","v":{"v":230343.84,"d":"=$230,344"}},null,{"$f":"J88*12","v":{"v":237254.16,"d":"=$237,254"}},null,{"$f":"L88*12","v":{"v":244371.72000000003,"d":"=$244,372"}},null,{"$f":"N88*12","v":{"v":251702.88,"d":"=$251,703"}},null,{"$f":"P88*12","v":{"v":259254,"d":"=$259,254"}},null,{"$f":"R88*12","v":{"v":267031.56,"d":"=$267,032"}},null,{"$f":"T88*12","v":{"v":275042.52,"d":"=$275,043"}},null,{"$f":"V88*12","v":{"v":283293.83999999997,"d":"=$283,294"}},null,{"$f":"X88*12","v":{"v":291792.6,"d":"=$291,793"}},null,{"$f":"SUM(E90:W90)","v":{"v":2563717.56,"d":"=$2,563,718"}},{"$f":"Y90/10","v":{"v":256371.756,"d":"=$256,372"}}]
[null,"Tier 3 Concurrent Audit Monthly Administrative Fee"]
[null,"For a PLI program with greater than 250 Active Members",null,"Total Monthly Cost",{"v":18635.87,"d":"$18,635.87"},{"$f":"E92*$C$116","v":{"v":18635.87,"d":"$18,635.87"}},{"v":19195.32,"d":"$19,195.32"},{"$f":"G92*$C$116","v":{"v":19195.32,"d":"$19,195.32"}},{"v":19771.18,"d":"$19,771.18"},{"$f":"I92*$C$116","v":{"v":19771.18,"d":"$19,771.18"}},{"v":20364.31,"d":"$20,364.31"},{"$f":"K92*$C$116","v":{"v":20364.31,"d":"$20,364.31"}},{"v":20975.24,"d":"$20,975.24"},{"$f":"M92*$C$116","v":{"v":20975.24,"d":"$20,975.24"}},{"v":21604.5,"d":"$21,604.50"},{"$f":"O92*$C$116","v":{"v":21604.5,"d":"$21,604.50"}},{"v":22252.63,"d":"$22,252.63"},{"$f":"Q92*$C$116","v":{"v":22252.63,"d":"$22,252.63"}},{"v":22920.21,"d":"$22,920.21"},{"$f":"S92*$C$116","v":{"v":22920.21,"d":"$22,920.21"}},{"v":23607.82,"d":"$23,607.82"},{"$f":"U92*$C$116","v":{"v":23607.82,"d":"$23,607.82"}},{"v":24316.05,"d":"$24,316.05"},{"$f":"W92*$C$116","v":{"v":24316.05,"d":"$24,316.05"}}]
[{"$nulls":4},"X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months","X 12","months"]
[null,"Tier 3 Evaluation Cost",null,null,{"$f":"F92*12","v":{"v":223630.44,"d":"=$223,630"}},null,{"$f":"H92*12","v":{"v":230343.84,"d":"=$230,344"}},null,{"$f":"J92*12","v":{"v":237254.16,"d":"=$237,254"}},null,{"$f":"L92*12","v":{"v":244371.72000000003,"d":"=$244,372"}},null,{"$f":"N92*12","v":{"v":251702.88,"d":"=$251,703"}},null,{"$f":"P92*12","v":{"v":259254,"d":"=$259,254"}},null,{"$f":"R92*12","v":{"v":267031.56,"d":"=$267,032"}},null,{"$f":"T92*12","v":{"v":275042.52,"d":"=$275,043"}},null,{"$f":"V92*12","v":{"v":283293.83999999997,"d":"=$283,294"}},null,{"$f":"X92*12","v":{"v":291792.6,"d":"=$291,793"}},null,{"$f":"SUM(E94:W94)","v":{"v":2563717.56,"d":"=$2,563,718"}},{"$f":"Y94/10","v":{"v":256371.756,"d":"=$256,372"}}]
[]
[]
[]
[null,"Table C "]
[null,"Instructions: Complete the section below by entering the Hourly Rate in the yellow boxes for each identified Role. As may be requested by the State on a case by case basis and agreed upon by the Contractor, the Contractor will provide ad hoc services related to potential tasks as described below.\n\nNote: These charges will only be billed for project-related services not specified in the eRFP and requested by the State for such services in writing. The total cost for all State requested and approved projects shall not exceed the amount indicated by the State in its Participating Addendum. The proposed costs will not be evaluated as part of the total contract value."]
[null,"Ad Hoc Professional Services",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Average of Hourly Rates"]
[null,"Role","Potential Responsibilities",null,"Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate"]
[null,"Business Analyst","Evaluates business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing Solutions.",null,{"v":89,"d":"$89.00"},{"$f":"MAX(ROUND(E102*$C$116,2),0)","v":{"v":89,"d":"$89.00"}},{"v":91.67,"d":"$91.67"},{"$f":"MAX(ROUND(G102*$C$116,2),0)","v":{"v":91.67,"d":"$91.67"}},{"v":94.42,"d":"$94.42"},{"$f":"MAX(ROUND(I102*$C$116,2),0)","v":{"v":94.42,"d":"$94.42"}},{"v":97.25,"d":"$97.25"},{"$f":"MAX(ROUND(K102*$C$116,2),0)","v":{"v":97.25,"d":"$97.25"}},{"v":100.17,"d":"$100.17"},{"$f":"MAX(ROUND(M102*$C$116,2),0)","v":{"v":100.17,"d":"$100.17"}},{"v":103.18,"d":"$103.18"},{"$f":"MAX(ROUND(O102*$C$116,2),0)","v":{"v":103.18,"d":"$103.18"}},{"v":106.28,"d":"$106.28"},{"$f":"MAX(ROUND(Q102*$C$116,2),0)","v":{"v":106.28,"d":"$106.28"}},{"v":109.47,"d":"$109.47"},{"$f":"MAX(ROUND(S102*$C$116,2),0)","v":{"v":109.47,"d":"$109.47"}},{"v":112.75,"d":"$112.75"},{"$f":"MAX(ROUND(U102*$C$116,2),0)","v":{"v":112.75,"d":"$112.75"}},{"v":116.13,"d":"$116.13"},{"$f":"MAX(ROUND(W102*$C$116,2),0)","v":{"v":116.13,"d":"$116.13"}},{"$f":"(F102+H102+J102+L102+N102+P102+R102+T102+V102+X102)/10","v":{"v":102.03200000000001,"d":"$102.03"}}]
[null,"Senior Developer","Responsible for designing, testing, and implementing new and updated software programs.",null,{"v":151.44,"d":"$151.44"},{"$f":"MAX(ROUND(E103*$C$116,2),0)","v":{"v":151.44,"d":"$151.44"}},{"v":155.98,"d":"$155.98"},{"$f":"MAX(ROUND(G103*$C$116,2),0)","v":{"v":155.98,"d":"$155.98"}},{"v":160.66,"d":"$160.66"},{"$f":"MAX(ROUND(I103*$C$116,2),0)","v":{"v":160.66,"d":"$160.66"}},{"v":165.48,"d":"$165.48"},{"$f":"MAX(ROUND(K103*$C$116,2),0)","v":{"v":165.48,"d":"$165.48"}},{"v":170.44,"d":"$170.44"},{"$f":"MAX(ROUND(M103*$C$116,2),0)","v":{"v":170.44,"d":"$170.44"}},{"v":175.55,"d":"$175.55"},{"$f":"MAX(ROUND(O103*$C$116,2),0)","v":{"v":175.55,"d":"$175.55"}},{"v":180.82,"d":"$180.82"},{"$f":"MAX(ROUND(Q103*$C$116,2),0)","v":{"v":180.82,"d":"$180.82"}},{"v":186.24,"d":"$186.24"},{"$f":"MAX(ROUND(S103*$C$116,2),0)","v":{"v":186.24,"d":"$186.24"}},{"v":191.83,"d":"$191.83"},{"$f":"MAX(ROUND(U103*$C$116,2),0)","v":{"v":191.83,"d":"$191.83"}},{"v":197.58,"d":"$197.58"},{"$f":"MAX(ROUND(W103*$C$116,2),0)","v":{"v":197.58,"d":"$197.58"}},{"$f":"(F103+H103+J103+L103+N103+P103+R103+T103+V103+X103)/10","v":{"v":173.60199999999998,"d":"$173.60"}}]
[null,"Developer","Responsible for developing, coding, installing, and maintaining software systems.",null,{"v":121.15,"d":"$121.15"},{"$f":"MAX(ROUND(E104*$C$116,2),0)","v":{"v":121.15,"d":"$121.15"}},{"v":124.78,"d":"$124.78"},{"$f":"MAX(ROUND(G104*$C$116,2),0)","v":{"v":124.78,"d":"$124.78"}},{"v":128.52,"d":"$128.52"},{"$f":"MAX(ROUND(I104*$C$116,2),0)","v":{"v":128.52,"d":"$128.52"}},{"v":132.38,"d":"$132.38"},{"$f":"MAX(ROUND(K104*$C$116,2),0)","v":{"v":132.38,"d":"$132.38"}},{"v":136.35,"d":"$136.35"},{"$f":"MAX(ROUND(M104*$C$116,2),0)","v":{"v":136.35,"d":"$136.35"}},{"v":140.44,"d":"$140.44"},{"$f":"MAX(ROUND(O104*$C$116,2),0)","v":{"v":140.44,"d":"$140.44"}},{"v":144.65,"d":"$144.65"},{"$f":"MAX(ROUND(Q104*$C$116,2),0)","v":{"v":144.65,"d":"$144.65"}},{"v":148.99,"d":"$148.99"},{"$f":"MAX(ROUND(S104*$C$116,2),0)","v":{"v":148.99,"d":"$148.99"}},{"v":153.46,"d":"$153.46"},{"$f":"MAX(ROUND(U104*$C$116,2),0)","v":{"v":153.46,"d":"$153.46"}},{"v":158.06,"d":"$158.06"},{"$f":"MAX(ROUND(W104*$C$116,2),0)","v":{"v":158.06,"d":"$158.06"}},{"v":138.87800000000001,"d":"$138.88"}]
[null,"Quality assurance/Test","Works with the development team to debug code, correct errors, and troubleshoot any issues with software code.",null,{"v":97.9,"d":"$97.90"},{"$f":"MAX(ROUND(E105*$C$116,2),0)","v":{"v":97.9,"d":"$97.90"}},{"v":100.84,"d":"$100.84"},{"$f":"MAX(ROUND(G105*$C$116,2),0)","v":{"v":100.84,"d":"$100.84"}},{"v":103.87,"d":"$103.87"},{"$f":"MAX(ROUND(I105*$C$116,2),0)","v":{"v":103.87,"d":"$103.87"}},{"v":106.99,"d":"$106.99"},{"$f":"MAX(ROUND(K105*$C$116,2),0)","v":{"v":106.99,"d":"$106.99"}},{"v":110.2,"d":"$110.20"},{"$f":"MAX(ROUND(M105*$C$116,2),0)","v":{"v":110.2,"d":"$110.20"}},{"v":113.51,"d":"$113.51"},{"$f":"MAX(ROUND(O105*$C$116,2),0)","v":{"v":113.51,"d":"$113.51"}},{"v":116.92,"d":"$116.92"},{"$f":"MAX(ROUND(Q105*$C$116,2),0)","v":{"v":116.92,"d":"$116.92"}},{"v":120.43,"d":"$120.43"},{"$f":"MAX(ROUND(S105*$C$116,2),0)","v":{"v":120.43,"d":"$120.43"}},{"v":124.04,"d":"$124.04"},{"$f":"MAX(ROUND(U105*$C$116,2),0)","v":{"v":124.04,"d":"$124.04"}},{"v":127.76,"d":"$127.76"},{"$f":"MAX(ROUND(W105*$C$116,2),0)","v":{"v":127.76,"d":"$127.76"}},{"v":112.24600000000001,"d":"$112.25"}]
[null,"Total Ad Hoc Professional Services Cost (Sum of 10-Year Average of Hourly Rates for all Identified Roles)",{"$nulls":22},{"$f":"SUM(Y102:Y105)","v":{"v":526.758,"d":"$526.76"}}]
[]
[]
[]
[null,"Table D"]
[null,"Consumer Price Index Urban (CPI-U) Adjustment:"]
[null,"A. CPI-U for Master Agreement Date MM/DD/20YY:",{"v":0,"d":"0.000000"}]
[null,"B. CPI-U for Participating Addendum Date:",{"v":0,"d":"0.000000"}]
[null,"C. Index Point Change equals B minus A:",{"$f":"C113-C112","v":{"v":0,"d":"0.000000"}}]
[null,"D. Equals C divided by A:",{"$f":"IFERROR(C114/C112,0)","v":{"v":0,"d":"0.000000"}}]
[null,"E. CPI-U Inflation Percentage equals B plus 1.00:",{"$f":"C115+1","v":{"v":1,"d":"1.000000"}}]

{"sheet":"Scoring Formula","index":2,"n_rows":15,"n_cols":2,"rows_kept":15,"merged":[[2,1,2,2],[3,1,3,2],[6,1,6,2],[9,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,15,3]]}
[]
[]
[null,"State of Georgia"]
[null,"In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[null,"Attachment X - Pharmacy FWA Audit Services Cost Worksheet"]
[]
[null,"Cost Scoring Formula"]
[]
[]
[null,"\nThe Supplier deemed to have the most competitive cost response overall, as determined by the Lead State, will receive the maximum score for the cost criteria. As a general rule, other Suppliers’ cost responses will receive a percentage of the maximum score based on the percentage differential between the most competitive cost proposal and the specific proposal in question. This cost scoring can be accomplished using the following formula:"]
[null,"\nL/R x P = Z\n\nL = Price of the Supplier's response with the lowest cost.\nR = Total cost of the Proposal being ranked.\nP = Total points available for cost scoring.\nZ = Assigned Points."]
[null,"EXAMPLE  - The Lead State receives responses from two Suppliers on an RFP.  The RFP assigned 700 possible points for technical scores and 300 possible points for cost scores. Supplier A's cost proposal is $50,000. Supplier B's cost proposal is $55,000. As Supplier A offered the lowest cost, Supplier A receives 300 points. The issuing officer can calculate the number of cost points to assign to Supplier B's cost score by using the formula noted above. As shown below, Supplier B's total cost score is 272.7 points.\n\nL/R x P = Z\n($50,000/$55,000) x 300 = Z\n.909 x 300 = Z\n272.7 = Z"]